﻿-- G7 https://en.wikipedia.org/wiki/G7
SELECT * FROM common.Country WHERE NAME LIKE 'FRANCE'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'GERMANY'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'ITALY'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'JAPAN'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'UNITED KINGDOM'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'UNITED STATES'
UNION SELECT * FROM common.Country WHERE NAME LIKE 'CANADA'

/*
The G7 began in 1975 as the Group of Six (G6) and included the countries of 
France, West Germany, Italy, Japan, United Kingdom, and United States and was joined by Canada the following year.

Collectively, the G7 nations comprised 50.4% of global nominal GDP and 39.3% of global GDP (PPP).
*/